Release 10.1A: OpenEdge Getting Started:
Core Business Services

Reporting on audit data with prefiltered and custom reports

As audit data accumulates in the auditing tables, you can generate audit reports about the data based on criteria you specify. There are two basic types of reports:

Prefiltered reports — Reports organized by category. You can specify the date range you are interested in capturing in each report. A list of the prefiltered reports appears in Table 14–4.
Custom filtered reports — Reports whose filter criteria, including date range, you establish.

To run these reports, you must have imported the preconfigured OpenEdge policies. For more information, see the Audit Policy Maintenance Help.

You can run the reports on all supported platforms. From Data Administration or the Data Dictionary, you can choose which report to run, a specific date range, what kind of output you want (terminal, printer, XML file, or text file), and how you want the report contents to display (in detail or summary format). You can assign each report a name, and you can decide if you want to append a new report to an existing one. You can also determine whether the report’s page length is fixed or continuous.

Figure 14–2 shows a report in detail orientation; Figure 14–3 shows a report in summary orientation.

Figure 14–2: Detail orientation report output

Figure 14–3: Summary orientation report output

To choose the specific report you want to run, choose Database Reports Auditing Reports; then either select from one of the prefiltered report types listed or choose to generate your own custom audit data filter report. For the specific steps you follow, see the Data Administration Help.

Table 14–4 lists each of the prefiltered reports and describes the information the report contains.

Table 14–4: Prefiltered audit data reports

Report name	Description	Events
Track Audit Policy Changes	Reports on audit policy changes.	Audit Policy Maintenance Events: record created, updated, or deleted. Audit Policy Commit Events: audit policy run-time update/ commit changes. Audit Policy Dump or Load Events: dump and load of audit policies.
Track Database Schema Changes	Reports on all possible schema modification actions.	Table created, updated, or deleted. Table trigger created, updated, or deleted. Table field created, updated, or deleted. Table field trigger created, updated, or deleted. Table index created, updated, or deleted. Table index field created, updated, or deleted. Sequence created, updated, or deleted. Database property created or updated.
Track Audit Data Administration (Dump/Load)	Reports on all archiving and loading of audit data.	Audit archive or audit data load.
Track Application Data Administration (Dump/Load)	Reports on archiving and loading of audit data.	Database text archive or load.
Track User Account Changes	Reports on user account activity.	User account created, updated, or deleted.
Track Security Permission Changes	Reports on privilege definition and privilege assignment activity.	Privilege definition created, updated, or deleted. Privilege assignment created, updated, or deleted.
Track SQL Permissions Changes	Reports on all possible SQL privilege modifications.	SQL database administrator created, updated, or deleted. SQL table privilege created, updated, or deleted. SQL column privilege created, updated, or deleted. SQL sequence privilege created, updated, or deleted.
Track Authentication System Changes	Reports on authentication system maintenance and authentication system domain maintenance activity.	Authentication System Maintenance Events: authentication system created, updated, or deleted. Authentication System Domain Maintenance Events: authentication domain created, updated, or deleted.
Client Session Authentication Report	Reports on all application access through authentication domains.	Each time an OpenEdge application uses an authentication system to authenticate a user.
Database Administration Reports (Utilities)	Reports on activities performed through command-line database administration utilities.	Database started, stopped, backed up, restored, or copied. Database binary dump or binary load. Database table moved. Database index moved, index checked, index rebuilt, or index fixed. Database area truncated. Database SQL dumped or loaded.
Database Access Report (Login/Logout/etc...)	Reports on all login- and logout-type activities on an OpenEdge database.	Database user identity set or failed. User login success, user logout, or user login failed. SQL user login success, logout, or user login failed. Database connect or disconnect. SQL database connect or disconnect.